www.gusucode.com > wxApp PHP版微信小程序CMS系统 v1.0PHP源码程序 > wxApp PHP版微信小程序CMS系统 v1.0/wxAppCMS_v1.0.0/wxAppCMS_v1.0.0/app/apps/admincp/apps.table.php
<?php if($rs['table'])foreach ($rs['table'] as $key => $tval) { $tbn = $tval['table']; ?> <div id="apps-add-<?php echo $key; ?>-field" class="app-table-list tab-pane"> <?php if(iDB::check_table($tbn,false)){ ?> <table class="table table-hover table-bordered"> <thead> <tr> <th style="width:100px;">字段</th> <th>数据类型</th> <th>长度</th> <th>主键</th> <th>非空</th> <th>Unsigned</th> <th>自增</th> <th>核对</th> <th>注释</th> </tr> </thead> <tbody> <?php $orig_fields = apps_db::fields($tbn); foreach ((array)$orig_fields as $field => $value) { ?> <tr> <td field="<?php echo $field; ?>"><b><?php echo $field; ?></b></td> <td><?php echo $value['type']; ?></td> <td><?php echo $value['length']; ?></td> <td><?php if($value['primary']){?> <font color="green"><i class="fa fa-check"></i></font> <?php }?></td> <td><?php echo $value['null']?'NULL':'NOT NULL'; ?></td> <td><?php echo strtoupper($value['unsigned']); ?></td> <td><?php if($value['auto_increment']){?> <font color="green"><i class="fa fa-check"></i></font> <?php }?></td> <td><?php echo $value['collation']; ?></td> <td><?php echo $value['comment']; ?></td> </tr> <?php } ?> </tbody> </table> <div class="clearfloat mb10"></div> <div class="span4"> <table class="table table-bordered bordered"> <thead> <tr> <th colspan="2">索引</th> </tr> </thead> <tbody> <?php $indexes = apps_db::indexes($tbn); foreach ((array)$indexes as $ikey => $ivalue) { ?> <tr> <td><b><?php echo $ivalue['type']; ?></b></td> <td><?php echo implode(',', (array)$ivalue['columns']); ?></td> </tr> <?php } ?> </tbody> </table> </div> <div class="span4 hide table_status"> <table class="table table-bordered bordered"> <thead> <tr> <th colspan="2">表信息</th> </tr> </thead> <tbody> <?php $table_status = apps_db::table_status($tbn); foreach ((array)$table_status as $tskey => $tsvalue) { ?> <tr> <td><b><?php echo $tskey; ?></b></td> <td><?php echo $tsvalue; ?></td> </tr> <?php } ?> </tbody> </table> </div> <?php }else{ echo '<div class="alert alert-error">'.$tbn.' 表不存在</div>'; } ?> </div> <?php }else{?> <?php }?>